Tabele

Tabela Accomodation

Definicja tabeli Accomodation

Name

Accomodation

Code

Accomodation

Comment

Zakwaterowanie


Lista kolumn tabeli Accomodation

Name

Code

AccomodationID

AccomodationID

EventID

EventID

AccomodationCode

AccomodationCode

StartDT

StartDT

StopDT

StopDT

Active

Active


Kolumna AccomodationID tabeli Accomodation

Definicja kolumny AccomodationID tabeli Accomodation

Name

AccomodationID

Code

AccomodationID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

ID zakwaterowania


Kolumna EventID tabeli Accomodation

Definicja kolumny EventID tabeli Accomodation

Name

EventID

Code

EventID

Data Type

NUMBER(19)

Mandatory

No

Comment

 


Kolumna AccomodationCode tabeli Accomodation

Definicja kolumny AccomodationCode tabeli Accomodation

Name

AccomodationCode

Code

AccomodationCode

Data Type

VARCHAR2(2)

Mandatory

Yes

Comment

Kod miejsca


Kolumna StartDT tabeli Accomodation

Definicja kolumny StartDT tabeli Accomodation

Name

StartDT

Code

StartDT

Data Type

DATE

Mandatory

Yes

Comment

Data od kiedy pacjent byl zakwaterowany


Kolumna StopDT tabeli Accomodation

Definicja kolumny StopDT tabeli Accomodation

Name

StopDT

Code

StopDT

Data Type

DATE

Mandatory

Yes

Comment

Data do kiedy pacjent byl zakwaterowany


Kolumna Active tabeli Accomodation

Definicja kolumny Active tabeli Accomodation

Name

Active

Code

Active

Data Type

NUMBER(5)

Mandatory

Yes

Comment

Aktywnosc rekordu


Lista kluczy tabeli Accomodation

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli Accomodation

Definicja klucza Identifier_1 tabeli Accomodation

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment